FindVBAObject

Finds specific VBA object in VBE project User need to setup to trust VBA ...

SettingRead_JR

Reads setting saved in columns J:R Just like SettingRead, but when we have ...

Convert2SQLDate

Converts a date (numeric date) into Date acceptable by SQL, as in YYYY-MM-DD ...

DeleteAllShapes

Delete all shapes in a sheet

1FileDB

DB in a File (One of my best library codes so far) Saves/Reads/Deletes certain ...

1FileDB.zip

DB_Setting1List + DB_Setting1List_NameValue

DB_Setting1List is to Returns list of SettingValues matching certain ...

DB_Setting2Read + DB_Setting2Save

Reads and save setting into settings table per 2 IDs, similar to SettingRead ...

Connect to UDL

Use a UDL to make your connection to a database

DB_AllRows

Returns all rows found from an SQL Query as string Separated by row and column ...

DB_Read1Row (DB_Read1stRow)

Reads from a table in a DB Reads only the first row, and return a string ...

DB_SettingRead + DB_SettingSave + ...

Reads/Saves specific settings from DB table Mainly for Classic ASP, but can be ...